﻿    /***************************************************************************************************
    **  Table:	    public.project_type
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered project type.
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.resource_type (name) VALUES ('Venue');
    INSERT INTO public.resource_type (name) VALUES ('Vehicle');
    INSERT INTO public.resource_type (name) VALUES ('Project');
    INSERT INTO public.resource_type (name) VALUES ('Human Resource');
    
    INSERT INTO public.resource_type (name) VALUES ('IIS Server');
    INSERT INTO public.resource_type (name) VALUES ('Sql Server');
    INSERT INTO public.resource_type (name) VALUES ('Universal Naming Convention Path');
    INSERT INTO public.resource_type (name) VALUES ('FTP Server');


	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.resource_type;